SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585590 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585590 [ RunTime:0.001802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868703,414576,588882,640102,510192,1026819,82294,30920,212083,528325,580973,703918,508470,375389,512581,33485,39445,102148,1022094,367903,861040,871282,290410,960537,732436,767421,964898,519020,370392,882770,211119,441747,426083,784768,344572,974110,587868,364802,67505,416505,942114,221175,392718,880946,581083,787452,423890,975437,1009133,181558,203817,283112,358533,395634,313921,260100,963223,307007,223759,249297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585590 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585590 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]