SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317299 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317299 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413711,104262,955157,519652,519735,731790,600125,575789,221155,955868,601560,368179,444310,406365,790225,794286,570954,713236,483330,884714,981029,123751,607646,669881,546114,792546,340397,344438,700379,729506,739008,647553,892809,468874,767386,371930,87520,481766,939905,639781,893451,934700,518657,277587,872930,400275,73175,14661,574927,199028,647214,179877,15620,420925,879783,518869,100254,631864,751887,42544) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317299 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317299 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]