SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 19808 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 19808 [ RunTime:0.002975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (165432,664471,71053,767362,101343,726967,886695,1033142,447285,284352,411826,743409,554817,335492,920887,819766,260143,256546,1048759,222919,962449,1021161,743453,517416,490147,549800,911180,68051,125088,944155,491821,669266,915904,712096,18245,271077,144559,285107,527784,1030931,396587,932743,848241,447015,841489,483671,484988,323379,400024,715485,517777,591404,575975,875496,22336,853085,789451,881543,661343,695815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 19808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 19808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]