SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001579s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806483 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806483 [ RunTime:0.004116s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (584549,592248,457011,440901,366472,331751,563638,645256,610485,325284,226033,702967,20769,106600,38411,124701,807334,380646,45921,1032489,644407,765510,975486,621008,922348,988758,249282,968202,397648,573547,578769,962837,401348,957755,320333,523856,951487,493646,448714,83757,773554,854062,6560,662272,679507,1009783,515301,578884,954849,850584,582343,714018,460197,706709,978842,449287,681116,624683,283087,524249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001624s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000640s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]