SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100220 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100220 [ RunTime:0.002347s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (765911,376269,43896,398565,287749,158011,198912,797157,732378,70015,358549,161442,401453,218343,559622,944907,799,379326,701069,912543,287881,51455,79504,1015790,704979,380078,438229,786812,594533,207269,571516,786331,319059,359824,874117,326706,595434,133971,274271,1032837,772294,903392,149776,641862,664264,844407,565161,780849,404737,59523,977305,970704,790526,269245,465613,255645,404019,420905,918387,771101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]