SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532740 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532740 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71971,652815,972326,986565,1029189,98931,792971,267381,342439,61339,1000744,113761,8802,98214,96792,605226,879119,414515,507101,690476,701864,407119,832386,25811,854144,663703,1043743,716973,665042,912920,701812,197537,287067,62022,989921,812577,121377,985680,722945,559484,506470,414759,420464,957281,787691,358165,24968,424896,784572,1015155,748407,287724,656530,185605,1011824,90448,724650,680863,85140,189174) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000956s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]