SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574291 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574291 [ RunTime:0.001676s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374971,973581,952208,809439,671838,24645,698566,452536,192254,431161,280767,638027,564047,915984,966732,629273,39798,441483,243662,703616,173247,431516,205424,746167,279963,267322,188801,423187,752803,734438,253502,113303,553039,479524,394647,982635,951052,537255,527286,31351,341087,688182,27518,991987,501114,917256,862358,68239,295798,594977,532272,734049,195799,191096,439054,144062,847935,301009,297708,350943) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]