SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563327 LIMIT 1 [ RunTime:0.000991s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563327 [ RunTime:0.002547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400529,773505,146233,279312,410397,870507,902471,626085,273313,13183,959248,3132,940150,254248,871612,213720,866679,914531,992490,165331,318858,927868,318923,149837,577948,907677,820488,444564,750709,924820,436750,218302,816714,589279,257901,333701,537858,891701,301186,536500,1041059,133080,739588,397535,40278,926391,564072,571976,338240,310574,316032,497832,867515,197394,354540,406307,456779,371658,579342,119828) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002316s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000573s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]