SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001811s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502763 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502763 [ RunTime:0.003851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (43830,817251,406620,235364,809105,341753,407143,884175,341982,295810,1002736,170324,491965,676404,570467,753760,494243,669647,361852,754351,945643,466315,442949,130661,36495,619825,423010,129630,679091,27775,476781,443567,565523,227568,544376,25984,364078,411936,522420,889560,489296,392680,648801,1001631,120384,657955,797271,990914,868180,677662,230826,355231,639046,525289,311127,797740,884667,560620,862130,569484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502763 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502763 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000835s ]