SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475712 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475712 [ RunTime:0.002655s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287266,165085,633822,505145,542632,970078,419241,1017204,383878,19763,441908,681661,552198,1029848,296057,250586,159743,222188,160440,446059,43358,1017770,738974,272692,425642,190264,721528,262651,726027,375449,377832,3227,881031,217616,474188,975543,426574,53997,644427,463005,781451,386030,909005,182033,767651,976402,1022818,373109,207127,256326,405335,26606,255509,551356,580199,479592,397699,80059,464794,951332) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]