SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106066 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106066 [ RunTime:0.002674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002077,825954,228698,1019107,105168,779923,175191,640736,589079,70704,104562,510103,313709,260240,415554,161269,632052,6892,459573,340985,961646,654639,861759,577591,113678,676420,430327,882448,800199,30516,241932,684320,699888,813625,672424,497551,784474,190700,984804,41445,488161,1039487,377514,933794,776348,150313,383063,474579,976254,861511,736683,388684,234029,855033,654630,514701,448085,395682,899820,334367) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106066 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106066 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]