SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545573 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545573 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510373,82148,319470,919597,533516,150578,598834,95033,980480,819076,369220,588319,406101,80463,1021709,742873,1005559,495691,568071,437354,901169,122748,202919,643963,444660,1030192,795352,869115,635711,810364,444624,563591,456138,112035,612860,27081,142141,256124,320946,87633,285579,276437,845851,868393,288296,431587,424125,938738,714881,756706,443939,962520,497770,439247,245665,321497,1026773,986193,294594,783836) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]