SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426428 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426428 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (70668,181544,1029931,99477,715562,954303,417434,1041990,915150,141923,227743,280601,411535,109166,374496,467891,457956,381444,249624,708249,576445,325182,636962,830180,391282,9755,410090,678720,228666,973538,18319,510339,271175,331191,670696,339395,507590,866638,329569,1021824,418627,363228,370153,11745,33542,956472,131557,462943,313121,482370,882557,1040741,767390,461267,418253,141134,624838,22074,407790,863297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]