SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415220 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415220 [ RunTime:0.001567s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235050,308040,657864,315389,477582,437690,674088,599804,863117,152671,248600,983775,724275,898269,538918,507971,924289,850684,446166,14874,446719,938827,382306,362456,308455,619890,369126,910878,119936,886817,470557,274990,1048192,378168,111039,14244,382862,269628,490535,699111,1006359,865495,420949,171846,392622,869613,356907,906669,273908,281670,711501,2663,22781,983932,944779,344503,215931,753970,858005,492916) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000595s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]