SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001855s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291096 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291096 [ RunTime:0.001992s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (667229,752103,7963,342828,605842,358691,872403,193945,866642,897702,385561,721993,871710,480174,182484,439155,462484,483582,991135,280147,986876,180632,730887,832963,431026,463238,133117,774811,693092,899924,776809,973489,538240,407109,413191,879969,316167,920704,100051,1041877,333688,968291,867678,381093,382887,249003,535470,1041034,131820,860433,71284,855264,355417,508241,198592,813958,611894,1034080,28466,478126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291096 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000586s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291096 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]