SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 38239 LIMIT 1 [ RunTime:0.000602s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 38239 [ RunTime:0.002345s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (532049,20371,385023,592547,348501,1042006,723799,367905,823704,744005,92910,592985,473484,237990,845167,693667,433780,134775,255234,121656,320172,218310,251449,568234,443414,302942,308689,206482,813167,496098,674435,277944,449874,144679,83227,235974,318108,494768,885653,852247,392587,637889,1040502,632338,450769,373420,968801,58974,267729,208131,475563,675245,882018,202455,130866,858815,362358,223993,796662,112852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 38239 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 38239 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]