SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406183 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406183 [ RunTime:0.002236s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (666891,692742,907273,431939,183626,720264,762490,52226,393650,670003,989424,132290,101907,941535,513828,415204,327840,708104,535408,667635,261780,428514,380784,306122,745191,853918,388694,286336,357983,375300,701491,305121,325776,751716,1019192,882172,352186,1035160,186115,103521,491113,369631,668322,785035,126988,261173,278496,567818,830020,903813,239533,963089,192736,703191,451661,404797,835650,430549,686653,419079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000788s ]