SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478540 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478540 [ RunTime:0.002834s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815005,524803,598428,821333,797402,665988,132223,149651,275100,1019593,719781,946182,556271,77508,401721,648896,586596,23781,126148,580329,55887,414352,667853,293800,662789,534579,495184,332191,556662,612673,185655,27849,612056,279277,599961,317105,98615,851412,534919,403358,519820,154453,926578,217028,62120,421683,794623,598261,1031826,158178,653262,355897,563,21289,57864,313433,65741,1007889,373198,778007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478540 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478540 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]