SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413791 LIMIT 1 [ RunTime:0.000502s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413791 [ RunTime:0.002099s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (753934,167482,234478,18026,955711,949527,202262,101889,612347,348883,886799,14080,860105,645942,776356,285747,350910,589720,600406,169052,756849,208154,874028,500300,229302,342975,777363,1002114,250209,245387,581340,831623,481403,120366,649167,473006,334037,720948,491763,132585,836636,697359,351632,498950,770110,463042,664179,461956,480940,510155,275444,212960,374782,831296,16349,937829,65441,68432,1005074,549605) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]