SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407305 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407305 [ RunTime:0.002640s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (808242,358579,600877,961985,4844,620329,156095,463126,247080,393077,560199,133038,839679,1039481,763122,702179,30753,815313,444071,390728,863516,1012084,504371,732478,966575,842346,486099,284203,1004846,921431,504742,233015,325798,449189,123276,606526,765016,765274,51524,424320,506307,862549,1022062,1004814,270129,870448,1043021,485249,1042557,5475,332503,683255,953536,283299,530447,91872,363559,851626,944509,457191) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001284s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407305 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407305 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000385s ]