SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467908 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467908 [ RunTime:0.001610s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (171903,768788,466065,612158,94522,316614,90133,112907,752876,438802,547064,551943,32667,341206,236685,217546,855778,754430,999048,824731,144641,24624,1007052,389675,306348,983459,226753,682973,842548,15230,664597,310086,993055,233322,43903,498750,41615,752608,122934,950287,237011,266805,705658,710692,74944,102338,71027,361687,621333,151100,259266,4002,139232,301212,275749,1012319,1033387,536300,818365,429670) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]