SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265575 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265575 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (589271,201714,136269,223347,354002,480207,885904,94706,308027,182427,62063,797619,73645,257932,20147,387760,1028889,790167,472741,387100,462792,1344,346961,286043,681695,338192,872436,621441,841922,1008540,744495,15982,335885,654500,402368,379406,1025267,863951,704309,144516,478920,787086,353743,26537,784484,678025,418720,305168,770514,533142,259686,989031,730696,499803,222603,761265,213829,77564,881834,737364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001729s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]