SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001950 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001950 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40702,28050,691446,704649,407844,227851,669978,181451,458448,10370,348872,731212,160545,743170,1002871,703105,480491,670574,328817,867031,467139,229700,488651,215287,353825,871332,973717,1020739,804144,759308,387955,748635,870798,434274,840875,682730,313018,340853,595446,410220,661834,459783,794706,407486,993514,848700,984465,865238,221940,878144,159910,181173,1011240,543338,793956,815448,549537,192204,32671,26494) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001950 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001950 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]