SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548504 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548504 [ RunTime:0.013033s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (878924,1038730,724105,519601,278637,674841,487454,532236,274005,1005618,123994,920224,536520,595745,43335,122119,999651,688151,687482,388389,79294,145324,189,304707,257192,83999,73721,699714,735280,874461,890075,97095,472924,977222,829296,783160,68997,1025874,41838,981881,1042735,932682,867711,649938,925224,667913,342985,100633,94582,91048,597379,39685,250405,627515,757498,337522,392375,1634,258423,8704) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000959s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001895s ]