SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041544 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041544 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200715,498863,917587,536078,767805,1018154,99974,734670,459378,56614,999095,175328,394218,846307,589747,832998,683187,377099,462058,882381,130247,840109,1030272,387238,772244,165722,500616,902046,582609,348092,988248,263527,219181,757253,199608,305913,728303,755014,240923,608728,517348,403809,326826,739842,311081,995080,209790,768241,579812,634736,272437,655846,719940,203637,208272,650606,745845,537680,539278,228180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041544 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041544 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]