SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005278 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005278 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (646262,371181,1044398,554516,527676,133867,939013,497123,956719,474529,9331,510843,650836,635778,26945,690513,1019779,821916,562285,326873,552786,179044,810227,855429,641762,470893,913431,124570,824300,428802,371926,1028767,765104,409134,124147,815187,237687,728801,120961,45700,515332,921949,657658,38996,558948,241394,321377,222815,792874,654264,82298,153394,697412,938711,972663,252019,871393,375386,987446,389949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005278 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005278 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000999s ]