SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001395s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44023 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44023 [ RunTime:0.001534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362255,555240,31410,7026,934449,400032,512284,48483,564127,157766,849464,570397,637536,217638,800338,345757,540308,905561,200490,771726,720402,60349,385048,584590,886906,309195,24011,389945,893656,720868,266078,35483,1036100,994695,961246,827996,753291,731903,927174,268142,501563,494008,659920,415941,173068,1030139,749683,1005169,657789,279838,878580,586605,135490,294149,189191,558371,635434,17554,1044381,780110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010696s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44023 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000774s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44023 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001627s ]