SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 270413 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 270413 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (490282,631555,637037,832893,155652,481326,540736,533302,800788,690518,437673,580104,141043,190183,217395,977603,400140,381330,252530,493782,126833,373923,677611,561630,948523,975883,999386,520828,167630,1009110,631178,479204,750461,658005,637676,726307,474470,305211,767916,1022026,739365,218146,477513,40681,608071,333505,653939,301135,924951,948212,587876,661119,934740,830253,440797,967100,268589,169677,504670,812144) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 270413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 270413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]