SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 117713 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 117713 [ RunTime:0.002246s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (313646,1038470,1028938,258964,32726,721340,812489,80813,725884,85188,220625,411423,1010981,331666,49644,333449,651988,827742,143567,827082,405859,712403,805413,469610,941740,863483,894996,783215,875750,31321,299751,538827,514645,907587,488596,910089,839594,342952,671875,146589,980599,747929,365671,35669,226783,1040583,176208,10570,7044,65885,648817,608122,793211,546822,243137,203780,10086,216875,974774,48391) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 117713 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 117713 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]