SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 246413 LIMIT 1 [ RunTime:0.001140s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 246413 [ RunTime:0.004004s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12091,495065,465526,332027,186716,40161,835059,848405,437320,662295,1027528,76447,788725,384229,965889,193026,37860,802315,1026139,342208,363423,481847,42498,24106,400298,1028940,1019325,929268,1043212,495368,621888,736092,673119,746737,16393,229890,210100,357023,720205,719138,21103,854460,134127,280061,444286,688643,449584,450513,309259,472245,86563,16225,347437,802036,378154,448941,664399,492347,1001629,950201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 246413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 246413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]