SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 141021 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 141021 [ RunTime:0.001976s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (833271,608884,65040,66963,397839,686244,945398,723252,715872,470406,495987,997318,152510,235347,452774,476179,997372,586669,121112,585418,327854,363095,710590,969305,472149,104646,781608,667637,78562,886920,612503,490023,823879,94317,722278,1014858,610151,562213,685132,693641,758901,119288,429334,748888,702775,855296,464186,764000,768684,432946,948792,977724,442463,655177,419065,309659,933835,886834,368080,639810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 141021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 141021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000663s ]