SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290712 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290712 [ RunTime:0.001536s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219191,925882,461213,97440,388347,931775,304358,103682,655468,684411,618195,1003592,380355,444519,359103,631212,6509,597186,342270,54778,853516,295790,553953,49643,655280,621084,360669,879918,195525,302563,139386,68411,1038406,1040060,372570,48042,789928,75610,670125,582141,693534,734502,99467,774373,226704,751811,567512,419527,664463,927843,930761,247617,55785,181512,755517,10895,917934,472928,258392,904630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]