SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453680 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453680 [ RunTime:0.001785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788040,147197,859119,250800,1026192,315735,892535,977538,564660,127389,345069,57611,848119,331533,164417,781509,298817,601477,451814,257575,208529,576769,409085,49938,334767,51814,627688,392269,277936,631432,548570,767306,477487,875840,729464,104205,573461,127322,995485,354863,3394,508608,677336,392505,549599,451837,22747,681466,137831,9193,740432,957082,833211,533395,442907,220449,625945,700336,139006,322667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]