SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 936991 LIMIT 1 [ RunTime:0.000679s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 936991 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454105,793392,551774,440256,972712,249857,132880,714818,352573,451080,992108,797555,197796,16510,248128,664414,470534,14769,908794,40787,66914,464885,18586,1031132,633117,650323,675219,950109,156449,784316,279095,836195,189284,503594,860486,306626,903833,895176,235281,861827,281315,844229,55259,668604,676379,359351,542227,149241,700799,505021,137971,400224,670470,847712,985366,722492,7770,68289,1008310,468053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 936991 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 936991 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]