SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504932 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504932 [ RunTime:0.002511s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041969,409463,185162,462067,917272,844344,988595,529859,1037929,169156,308437,974965,492926,265603,130973,349536,125031,72214,803174,316515,538195,521258,445906,998215,271074,86224,580988,144350,1037540,496477,810212,989930,408875,642676,1044778,719785,9948,119679,466047,907097,840739,1025543,1012201,125515,1046923,614242,971887,313977,538067,179912,342095,510691,467565,715778,564330,464490,828849,630961,729650,740544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504932 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504932 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]