SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568975 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568975 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (913117,744534,112198,762656,803491,911226,669599,727713,724497,849821,338980,86392,442059,980281,737620,271724,26547,1005568,17058,370209,94109,490186,428337,265421,843057,768945,414449,746500,467137,710243,515693,1031203,464214,788449,48754,622581,227822,1008407,938266,496782,343887,150736,745874,19758,287828,190435,915562,14976,569917,572058,801440,87129,499808,479263,435106,682930,217014,765132,153616,432418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]