SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 971143 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 971143 [ RunTime:0.003326s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (145643,452710,499172,132784,161187,828218,46837,459102,371165,598847,656483,475185,353242,947715,474355,692784,892122,850840,1002509,69491,956988,871311,738608,364297,245118,902005,690975,404974,796674,866260,755742,550472,123078,982720,560913,827453,934328,362550,859603,289613,922845,30147,919333,332952,355313,803928,314389,589808,208260,581200,799898,688555,568668,215975,611550,232429,104384,284488,1039124,514299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 971143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 971143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]