SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034222 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034222 [ RunTime:0.002342s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (351373,658110,466009,683383,70675,691156,461295,740875,797673,554492,320969,248670,1024362,343615,947636,624163,179666,909470,811337,839921,464582,146383,952442,794627,166461,386010,510451,326931,345403,185481,472666,983734,650710,269797,909133,566569,281033,53511,671417,944772,588594,686748,487395,244748,231462,726027,735545,52996,856522,878199,758736,934044,746850,579409,546007,361923,308388,945183,554586,913277) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034222 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034222 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]