SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001575s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453088 LIMIT 1 [ RunTime:0.000422s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453088 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (130106,1023785,744963,767182,434175,100171,151868,722156,566249,808430,342119,618427,889598,811019,807043,790828,808091,493858,329067,3239,201017,774606,127124,67725,90734,194321,574329,256285,91710,1002763,82467,498633,730645,44963,182408,216759,1005597,218748,939421,947807,461513,219862,127699,985100,14213,349944,500380,377128,566166,957221,1007953,269200,832452,933181,995128,269644,848220,593838,193240,128077) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453088 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453088 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]