SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405733 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405733 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24140,876563,309608,349941,170836,768950,831163,410663,989611,125677,854296,252396,133229,956842,751026,627378,764344,29006,217442,426566,508631,363119,28235,1041116,673109,527779,319238,916125,630714,449825,725627,219019,179577,956140,57424,458504,183741,159109,710203,451839,1000038,1027157,502135,408116,736785,610876,717832,1030469,2259,490251,970818,578639,578833,450285,73002,265358,334748,254605,407344,453813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000985s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405733 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405733 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000479s ]