SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004617s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020182 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020182 [ RunTime:0.003857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (970694,296750,1020012,725502,618617,484310,260360,219579,732719,957961,976456,929316,811163,814895,686063,796472,697314,998724,25871,111061,736302,159576,536996,9693,798713,737310,722043,979578,1007849,783734,473740,275245,323689,856401,597749,1035404,989333,749491,975751,710169,525142,596265,474010,42625,367828,829454,323706,465082,191974,144764,435838,474275,190050,494067,219455,778348,228192,173839,340068,947113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020182 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020182 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000779s ]