SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 64380 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 64380 [ RunTime:0.002478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (185924,628960,213688,399735,114735,28552,180921,1039896,254096,557200,359642,810539,247270,322805,624199,580299,351988,488166,407344,628987,680190,353214,960681,320876,911231,180554,1046538,99625,483517,453299,80554,927014,861391,496850,801461,465317,293290,583195,534407,426214,246653,938250,577247,392017,403272,32153,134631,860089,962366,172459,940483,707250,3549,228021,437426,715379,189440,862060,383872,174655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 64380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 64380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]