SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 297218 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 297218 [ RunTime:0.002687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698765,433708,521855,184472,781106,420186,98909,507493,758988,840979,986578,940464,701935,668264,243254,643557,454998,852706,157050,507188,610043,538415,75135,713135,147536,825047,947168,334423,362154,842603,728909,132176,128339,969881,765549,37160,138543,813658,25389,1004390,970108,450017,431454,1018202,220770,1806,702340,464745,778747,226348,712837,481885,641730,717693,752953,336391,562748,90399,1048748,640814) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001603s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 297218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 297218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]