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` = 1047183 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047183 [ RunTime:0.001958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539791,146561,472772,18449,140436,506645,71215,929097,203882,228629,746823,736140,223005,384058,38467,840091,356871,700339,497829,1030050,295148,521586,141557,511384,263075,446822,724722,675874,740788,490226,956627,299471,355637,486647,1022375,961690,719588,383897,145972,852706,424397,593423,103426,421237,974632,293332,331968,421219,4179,223154,432535,269456,40629,30315,60645,66338,779362,672303,310913,333366) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]