SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526528 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526528 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257211,733670,401436,573659,943486,735517,973117,856883,453376,75239,607165,483794,439039,428536,370186,795554,489077,856677,912876,72376,525246,285473,52800,335442,921109,115488,163224,230884,93837,345861,629153,803254,564916,816889,243668,181567,285723,395056,414328,201814,263569,326665,374063,206832,56476,745956,791885,279979,536759,228368,21440,213695,606695,623168,578205,418463,819266,673742,65218,972700) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000999s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526528 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526528 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]