SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563974 LIMIT 1 [ RunTime:0.000280s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563974 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793828,155370,617700,116886,643845,684730,160524,625729,997524,889963,90460,831818,1021617,898132,1038819,600525,419589,284913,874084,266094,350080,454688,1027182,544232,170693,284636,26941,108597,935449,832185,1003498,374897,841127,598170,937332,821049,885272,352716,719057,112073,644138,580005,999640,436803,464620,839344,1044570,861201,877288,506379,726092,531244,935786,519408,323526,134829,661525,639470,314255,450523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000948s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]