SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 313904 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 313904 [ RunTime:0.002015s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103563,33131,1004571,253748,304121,362798,1018126,661625,668544,257326,320304,205977,534279,710130,425180,850043,272172,249434,679719,557522,854645,995321,569456,256043,1018262,175004,398755,517577,640986,717482,302033,325938,828076,1027208,130763,274841,566404,500954,948661,898258,620931,1009429,928677,1038382,1014054,501769,779256,283320,955497,32860,55323,946306,856864,524235,399051,924431,851897,567445,963900,673721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 313904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 313904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]