SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001280s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544048 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544048 [ RunTime:0.001766s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (934360,613137,575829,37117,41630,939666,349536,262159,723039,1028125,203137,951794,1033502,683354,213679,478073,83696,1044135,587543,838724,466197,620177,545628,328159,917142,192483,294277,889729,385846,319082,429924,795993,988067,553653,852273,422592,1027217,113370,695906,713512,309180,319232,78023,150778,850478,796423,381710,525783,268148,338091,235357,784620,35039,983607,1043305,305584,903191,1039141,195373,307991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]