SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023083 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023083 [ RunTime:0.002749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (974959,943318,695844,304082,652404,954315,1038103,566212,87086,680576,637654,756366,435791,541925,593493,633742,399467,591045,610542,779429,1013748,472307,553040,680256,682961,337790,946526,765863,897895,510184,855061,121331,813792,743467,811791,494586,207491,739373,971984,416585,236103,298465,793098,783697,625334,687412,389141,827384,1025901,900396,307056,992839,870436,636266,29379,882399,157637,130102,51920,385237) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000532s ]