SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 283348 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 283348 [ RunTime:0.003491s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459511,18800,604294,735798,428372,387799,316034,726082,780295,990490,139491,949193,871255,760368,913178,238717,969057,820694,399035,50266,552953,1046161,41435,978314,944788,225029,238857,404717,485623,885183,993135,280717,159028,494399,119534,776074,824437,857588,256293,171924,437118,892137,888019,247226,125422,448002,985558,819042,782574,882016,583291,486348,238246,625118,781489,740864,353597,291877,678747,939489) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 283348 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 283348 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001172s ]