SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 144522 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 144522 [ RunTime:0.002025s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614632,1040724,718271,422272,370645,118979,375034,1032243,770233,850900,936038,407515,740540,649008,318460,893855,829891,971872,125335,801524,673630,807830,741914,321656,996689,342758,933928,946533,280423,1018497,203585,398333,407813,1024095,300364,111986,646109,937799,248420,1028166,22566,566108,607123,153685,120664,860651,318380,805103,160983,922356,372014,958145,474629,902622,11697,684836,74183,500428,863259,123205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000987s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 144522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 144522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]