SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473542 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473542 [ RunTime:0.001465s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039360,43364,6839,248784,625863,958673,831487,43820,600087,143008,784462,14024,678363,975707,718993,105457,497441,672924,951731,382043,808141,664317,1042781,36133,1001855,126596,532843,1033454,672402,643117,755682,136775,888592,170618,613854,272211,81312,113685,832384,158999,433827,37556,125841,542465,780960,764019,1018338,280061,237314,35376,859895,88657,317644,406808,56951,125658,809506,568541,95086,263640) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002314s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473542 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473542 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]