SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50463 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50463 [ RunTime:0.001519s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (780619,155332,484847,450664,862421,852956,938006,837669,27695,611962,285628,320139,227029,14221,598831,189805,973534,594528,648435,214879,36715,645378,333404,550258,471724,736983,489665,442502,403148,274482,136541,754541,819955,30266,705594,92717,943791,924285,647021,587746,318673,803775,80491,390216,605773,1041280,108459,614176,772576,932874,846251,601337,76351,358153,393507,502034,375445,240709,330778,532140) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001629s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50463 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50463 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]