SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507706 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507706 [ RunTime:0.003449s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010632,463595,833191,1033004,42286,341356,529866,785333,863114,995762,493313,908411,658325,173950,415466,715706,965236,209300,363207,170410,920449,508038,154805,33102,244759,614449,967320,883778,157947,237566,720620,150433,1014363,517352,369810,534206,97768,90632,40458,453796,787362,663878,433236,30628,206525,495784,650714,126202,385289,153648,54301,545477,607812,339326,591723,530420,814801,445673,557910,613338) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000780s ]