SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 446180 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 446180 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583449,436269,195682,212864,146759,673241,733214,955881,327336,401524,961675,672483,1021024,1035914,659124,473829,233873,394620,793512,169994,576379,558061,9160,661693,785669,291055,629222,786374,47765,962,631258,375834,136826,1008215,838205,1027337,23678,710210,753858,1025692,351688,649593,5162,618831,713227,232718,916255,660045,375316,364001,511486,469199,897245,621946,715452,968032,161757,657274,754911,752457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 446180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000496s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 446180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]