SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294241 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294241 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009794,414323,38286,339626,974683,209575,420203,963824,910172,470176,50703,341117,598120,1033802,169011,996035,919382,213191,885151,721382,876810,341714,646931,242623,981827,346815,301818,498615,15027,122155,699906,448954,872894,44127,539419,282338,267015,792579,850447,155797,374289,160551,448463,204374,544702,682958,956967,768448,864931,263183,298445,835822,2422,658303,975784,756014,261516,283364,6810,409428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000541s ]