SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100513 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100513 [ RunTime:0.002558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (308570,640275,207087,846820,131074,824274,411612,268716,183524,378513,499441,967563,866747,688148,407818,963552,957892,50987,758130,1029315,936217,5007,186174,576471,622416,454897,914468,244046,674016,492223,4501,746824,1019756,977534,271945,724571,890885,493554,604601,819274,288926,111154,363279,453244,1035177,731369,286030,756393,810238,748119,1029691,222637,897654,276971,865972,83310,1036769,313166,500967,565410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]