SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201309 LIMIT 1 [ RunTime:0.000289s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201309 [ RunTime:0.001440s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (953821,625857,742707,222053,908342,821058,834338,537244,744962,1037932,257821,324844,232824,486563,156238,551169,68223,549248,45927,984308,858805,863637,469382,1023319,946950,329133,353229,502757,988888,462028,1017281,784450,484291,754481,632916,166318,149849,113598,1025140,345788,506150,71577,567957,84000,814944,939163,254743,636015,20102,452277,1024081,696486,78238,992004,34923,587859,115665,989838,259154,799856) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]