SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 949741 LIMIT 1 [ RunTime:0.000522s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 949741 [ RunTime:0.001835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021097,799406,34596,191863,864745,410912,136137,482184,347219,486685,622117,553864,1035650,659894,59409,72020,369451,682805,218051,771101,255041,625250,147527,181844,495775,432999,233762,630367,25708,873841,239200,774488,186713,373143,175345,178177,833023,900191,963050,31465,347522,479959,797520,519677,781353,702168,658362,285112,110865,36356,488904,659451,386490,91828,838562,498626,585704,375334,644987,317740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001744s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 949741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 949741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]