SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44161 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44161 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013319,826098,339682,974879,651117,707887,717615,854658,128974,650137,667964,439121,438890,407651,351982,215677,936710,659427,411315,800514,117519,643529,504090,322821,862190,188829,186429,312067,310632,1039562,496682,396754,747117,1026524,809119,398391,268411,359469,89057,844256,484257,184535,927594,802438,42906,212686,1037422,749304,583711,487198,559764,224553,412625,84451,705657,95474,999375,415219,904707,289821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44161 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000585s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44161 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]