SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310631 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310631 [ RunTime:0.002751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416247,471278,220037,1002170,825236,555775,518551,659243,298018,344686,852509,99356,62369,891502,778577,40519,232635,510243,634049,66262,972118,162366,626390,647825,266209,747812,24018,273922,47893,601711,574006,417110,955122,333712,937950,881259,178430,551921,770874,23953,885993,957240,975179,692156,656657,504582,508112,946854,443482,245609,48992,542251,34080,557561,80801,752082,278086,884583,732766,309660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310631 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310631 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004958s ]