SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001394s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003404 LIMIT 1 [ RunTime:0.000454s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003404 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425930,112651,507315,313940,697939,157167,257681,913666,747421,56920,715559,1032645,500280,356558,672592,611894,22951,751444,477796,828496,663051,859308,743014,404999,31218,878233,992824,828145,907122,224002,629450,511351,511398,130044,268540,557910,353179,235727,918195,477053,985868,284856,823441,465108,40981,244375,532745,1029275,956176,551664,80364,890867,864635,528372,837508,120638,607696,74885,852988,262816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003404 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003404 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]