SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467994 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467994 [ RunTime:0.001948s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523934,346689,676771,946140,509039,106234,141202,505856,60463,51449,637479,300677,841549,564743,446501,107947,345408,103220,327796,889732,1001794,853856,637621,483326,477386,114931,911136,247836,886564,88417,253679,819776,413600,919268,725038,920341,139427,344483,652910,843013,368549,655067,522641,828355,195382,344163,937107,901257,320223,653686,42996,1008688,923712,970535,723527,547702,430670,564390,193882,942153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467994 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467994 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000451s ]