SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433028 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433028 [ RunTime:0.002040s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (609189,147548,630039,166685,548388,109050,163395,262284,539100,779971,999047,372184,168217,168050,684752,1041507,202907,292311,965512,321671,687059,159648,603394,841707,645751,119909,546778,134497,278616,256724,723030,154012,413560,387875,508873,200593,613857,751337,332197,856804,943412,398633,728477,1045570,621303,936893,339298,869229,564586,607345,29095,971810,337282,320854,643806,358638,754313,249913,474866,269821) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000326s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]