SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 503508 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 503508 [ RunTime:0.001698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721142,254946,597179,44774,173196,238172,62882,219735,199173,147242,243988,780552,845938,582916,186899,782758,615455,599869,880635,62558,580576,242445,473100,915600,113318,570708,735235,798672,901535,270614,37412,44498,104763,497800,678408,586749,144696,496179,688446,266346,548011,682439,229320,902718,7230,482852,872779,620598,36729,513343,134523,509611,316017,1011964,184083,102343,853898,87093,879718,108967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 503508 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000755s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 503508 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]