SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047708 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047708 [ RunTime:0.001956s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (32068,215808,537042,310396,452430,79504,827081,347513,726988,178155,757007,82671,82529,642926,247754,787,502337,387379,463726,650636,326613,943420,697100,237057,295490,949790,231069,212653,541488,363477,903456,1028052,699490,334801,477438,477802,636484,376294,724385,518725,70242,990600,520187,608417,450261,462457,590401,162781,863943,377275,27986,947796,485260,289873,615851,408181,916552,500965,694335,919321) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000481s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]