SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 513815 LIMIT 1 [ RunTime:0.000553s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 513815 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (127203,776176,502650,778118,1008381,822730,753619,732465,605013,226455,437653,339765,888073,700408,453566,63948,829787,499068,870199,1025517,121075,74331,772293,657878,188236,938727,777217,205632,653764,261562,120568,533066,53191,464815,313197,213804,56722,75460,224972,434542,441887,216815,649087,730825,481084,1010703,33949,586538,561368,101206,1041910,807782,987616,566797,682899,632913,302240,854355,93360,27109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 513815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 513815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000661s ]