SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047983 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047983 [ RunTime:0.001619s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (388740,420149,9704,705851,865222,995202,757571,732230,888377,484780,326261,387067,614598,703244,877861,755214,525996,746899,247592,384626,530107,1035567,68083,639773,416767,183654,851183,109441,667708,1034005,142505,299529,689284,427442,507031,978138,720558,123837,682169,1029292,225757,449715,319958,457455,254757,306365,825292,363829,227264,985354,975130,596307,974908,480437,867714,623338,443063,386002,981184,309956) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000844s ]