SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54442 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54442 [ RunTime:0.001742s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710561,814876,466674,104309,732027,776723,553657,745179,461964,53946,628694,845261,974577,107724,513009,618959,1002107,155747,638392,407267,181847,676300,1042434,344891,996986,609265,294391,946085,283675,798094,253518,676040,555917,970786,759666,607863,558595,974203,164514,464596,20732,1007733,108294,665605,541921,416823,906816,950202,486869,305625,112102,415435,397433,55753,272915,830332,236256,319098,211511,306483) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54442 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54442 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]