SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467963 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467963 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (481249,349413,603499,806391,450990,918456,591140,183394,855199,439403,842114,226916,889282,165521,63247,107587,422505,517085,516181,749372,375295,426742,218713,980488,418242,609562,186465,932412,1013501,130767,880872,231893,459672,64136,928636,105757,768385,374926,550035,989671,21553,738131,294536,589862,481144,247122,999469,509001,263664,1020580,87039,659338,394184,901551,140462,700565,1006496,169085,831824) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467963 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467963 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]