SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473791 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473791 [ RunTime:0.002403s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018695,670185,10800,532780,651364,515047,968713,829149,283944,392742,819128,395918,967500,518067,610211,691663,407869,895304,656848,736893,256136,107052,791491,205917,601941,715102,569144,1048473,289264,320251,287936,507429,7721,286066,430099,785313,564631,176419,274211,657043,933051,18833,350856,532988,40235,963548,554175,743223,269893,347163,134316,320952,964108,428953,323780,555186,257978,723300,721347,488703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.008330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]