SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 567948 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 567948 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533364,1035496,930486,716119,276514,34961,548070,501770,791257,301010,731375,89115,1016070,208374,271357,592502,865204,163248,638435,971887,980863,768592,355175,965523,199381,949377,237448,675594,866928,77717,929848,95595,135695,876137,374064,848484,82011,956981,1004237,986828,564605,799596,150624,292767,925798,469038,913748,805721,655157,629621,221901,993810,432902,679455,924779,947807,405310,77585,735139,426456) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 567948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 567948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001712s ]