SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583813 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583813 [ RunTime:0.001495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15297,404031,892187,589301,968902,621261,987872,258627,260762,882689,305586,961029,196658,134444,968841,731688,359896,1017699,613617,350137,868251,330052,818514,393386,470113,69694,140351,735669,311218,509131,1029899,13773,1042135,452819,531224,38525,307564,1030219,922387,788313,951947,447106,765591,388172,217377,692556,705672,612343,953012,282434,320446,67074,40539,796974,260399,376442,805624,967362,624401,350397) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]