SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 644312 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 644312 [ RunTime:0.003711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (290146,114079,1003651,754033,851038,498769,472154,765007,914628,487124,1520,253875,313749,566136,129035,337928,203948,849068,509165,847746,800572,637114,436146,85903,37164,202204,592103,673116,756350,740160,117019,449847,852286,47918,507305,437957,536990,248454,648232,953165,273916,452582,781034,483783,418399,253465,176693,743707,233932,1013716,192767,787039,82431,575820,417444,852682,977816,33925,472078,661131) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 644312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000471s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 644312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000397s ]