SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471718 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471718 [ RunTime:0.002012s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721551,577363,504310,58069,867056,116069,62598,3929,231829,87662,403319,251247,497986,653382,680264,770179,171835,231845,265401,369771,628459,58356,959062,935947,7369,536500,241091,1045371,387748,153721,1047655,878626,527905,75133,809483,866013,172092,568378,357682,911452,398817,681925,598775,327472,305353,694678,209857,133048,467384,220306,301443,463210,325684,335330,634331,724452,755652,529585,776867,662378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001085s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]